﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="Asset" targetNamespace="http://tempuri.org/Asset.xsd" xmlns:mstns="http://tempuri.org/Asset.xsd" xmlns="http://tempuri.org/Asset.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="2" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="assetManagementConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="assetManagementConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CocisModel.Properties.Settings.GlobalReference.Default.assetManagementConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AssetManageBeiJingConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AssetManageBeiJingConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CocisModel.Properties.Settings.GlobalReference.Default.AssetManageBeiJingConnectionString" Provider="System.Data.SqlClient" />
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="AssetManageConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="AssetManageConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CocisModel.Properties.Settings.GlobalReference.Default.AssetManageConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GeneralSoftwareInfoTableAdapter" GeneratorDataComponentClassName="GeneralSoftwareInfoTableAdapter" Name="GeneralSoftwareInfo" UserDataComponentName="GeneralSoftwareInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AssetManageConnectionString (Settings)" DbObjectName="AssetManage.dbo.GeneralSoftwareInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[GeneralSoftwareInfo] WHERE (([GeneralSoftwareID] = @Original_GeneralSoftwareID) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_SoftwareName = 1 AND [SoftwareName] IS NULL) OR ([SoftwareName] = @Original_SoftwareName)) AND ((@IsNull_SoftwareVersion = 1 AND [SoftwareVersion] IS NULL) OR ([SoftwareVersion] = @Original_SoftwareVersion)) AND ((@IsNull_LicenseID = 1 AND [LicenseID] IS NULL) OR ([LicenseID] = @Original_LicenseID)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_GeneralSoftwareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="GeneralSoftwareID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoftwareName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoftwareName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoftwareVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoftwareVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[GeneralSoftwareInfo] ([GeneralSoftwareID], [SiteCodeID], [SoftwareName], [SoftwareVersion], [LicenseID], [StatusID], [WarrantyStartDate], [WarrantyEndDate], [VendorID]) VALUES (@GeneralSoftwareID, @SiteCodeID, @SoftwareName, @SoftwareVersion, @LicenseID, @StatusID, @WarrantyStartDate, @WarrantyEndDate, @VendorID);
SELECT GeneralSoftwareID, SiteCodeID, SoftwareName, SoftwareVersion, LicenseID, StatusID, WarrantyStartDate, WarrantyEndDate, VendorID FROM GeneralSoftwareInfo WHERE (GeneralSoftwareID = @GeneralSoftwareID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@GeneralSoftwareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="GeneralSoftwareID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoftwareName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoftwareVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT GeneralSoftwareID, SiteCodeID, SoftwareName, SoftwareVersion, LicenseID, StatusID, WarrantyStartDate, WarrantyEndDate, VendorID FROM dbo.GeneralSoftwareInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[GeneralSoftwareInfo] SET [GeneralSoftwareID] = @GeneralSoftwareID, [SiteCodeID] = @SiteCodeID, [SoftwareName] = @SoftwareName, [SoftwareVersion] = @SoftwareVersion, [LicenseID] = @LicenseID, [StatusID] = @StatusID, [WarrantyStartDate] = @WarrantyStartDate, [WarrantyEndDate] = @WarrantyEndDate, [VendorID] = @VendorID WHERE (([GeneralSoftwareID] = @Original_GeneralSoftwareID) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_SoftwareName = 1 AND [SoftwareName] IS NULL) OR ([SoftwareName] = @Original_SoftwareName)) AND ((@IsNull_SoftwareVersion = 1 AND [SoftwareVersion] IS NULL) OR ([SoftwareVersion] = @Original_SoftwareVersion)) AND ((@IsNull_LicenseID = 1 AND [LicenseID] IS NULL) OR ([LicenseID] = @Original_LicenseID)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)));
SELECT GeneralSoftwareID, SiteCodeID, SoftwareName, SoftwareVersion, LicenseID, StatusID, WarrantyStartDate, WarrantyEndDate, VendorID FROM GeneralSoftwareInfo WHERE (GeneralSoftwareID = @GeneralSoftwareID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@GeneralSoftwareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="GeneralSoftwareID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoftwareName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SoftwareVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_GeneralSoftwareID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="GeneralSoftwareID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoftwareName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoftwareName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SoftwareVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SoftwareVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SoftwareVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LicenseID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LicenseID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="GeneralSoftwareID" DataSetColumn="GeneralSoftwareID" />
              <Mapping SourceColumn="SiteCodeID" DataSetColumn="SiteCodeID" />
              <Mapping SourceColumn="SoftwareName" DataSetColumn="SoftwareName" />
              <Mapping SourceColumn="SoftwareVersion" DataSetColumn="SoftwareVersion" />
              <Mapping SourceColumn="LicenseID" DataSetColumn="LicenseID" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="WarrantyStartDate" DataSetColumn="WarrantyStartDate" />
              <Mapping SourceColumn="WarrantyEndDate" DataSetColumn="WarrantyEndDate" />
              <Mapping SourceColumn="VendorID" DataSetColumn="VendorID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="PhysicalMachineInfoTableAdapter" GeneratorDataComponentClassName="PhysicalMachineInfoTableAdapter" Name="PhysicalMachineInfo" UserDataComponentName="PhysicalMachineInfoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AssetManageConnectionString (Settings)" DbObjectName="AssetManage.dbo.PhysicalMachineInfo" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[PhysicalMachineInfo] WHERE (([PhysicalID] = @Original_PhysicalID) AND ((@IsNull_ServerTypeID = 1 AND [ServerTypeID] IS NULL) OR ([ServerTypeID] = @Original_ServerTypeID)) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_UniqueNo = 1 AND [UniqueNo] IS NULL) OR ([UniqueNo] = @Original_UniqueNo)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_RackID = 1 AND [RackID] IS NULL) OR ([RackID] = @Original_RackID)) AND ((@IsNull_PositionInRack = 1 AND [PositionInRack] IS NULL) OR ([PositionInRack] = @Original_PositionInRack)) AND ((@IsNull_iLOIP = 1 AND [iLOIP] IS NULL) OR ([iLOIP] = @Original_iLOIP)) AND ((@IsNull_CPU = 1 AND [CPU] IS NULL) OR ([CPU] = @Original_CPU)) AND ((@IsNull_RAM = 1 AND [RAM] IS NULL) OR ([RAM] = @Original_RAM)) AND ((@IsNull_HardDisk = 1 AND [HardDisk] IS NULL) OR ([HardDisk] = @Original_HardDisk)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_EnclosureID = 1 AND [EnclosureID] IS NULL) OR ([EnclosureID] = @Original_EnclosureID)) AND ((@IsNull_PduID = 1 AND [PduID] IS NULL) OR ([PduID] = @Original_PduID)) AND ((@IsNull_KvmID = 1 AND [KvmID] IS NULL) OR ([KvmID] = @Original_KvmID)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)) AND ((@IsNull_VirtualCenter = 1 AND [VirtualCenter] IS NULL) OR ([VirtualCenter] = @Original_VirtualCenter)) AND ((@IsNull_VMVersion = 1 AND [VMVersion] IS NULL) OR ([VMVersion] = @Original_VMVersion)) AND ((@IsNull_VMClusterName = 1 AND [VMClusterName] IS NULL) OR ([VMClusterName] = @Original_VMClusterName)) AND ((@IsNull_BakServerName = 1 AND [BakServerName] IS NULL) OR ([BakServerName] = @Original_BakServerName)) AND ((@IsNull_Comments = 1 AND [Comments] IS NULL) OR ([Comments] = @Original_Comments)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniqueNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionInRack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iLOIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_iLOIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RAM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HardDisk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VirtualCenter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VirtualCenter" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VMVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VMVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VMClusterName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VMClusterName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BakServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BakServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comments" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[PhysicalMachineInfo] ([PhysicalID], [ServerTypeID], [AssetNo], [UniqueNo], [Brand], [Model], [SiteCodeID], [Floors], [RackID], [PositionInRack], [iLOIP], [CPU], [RAM], [HardDisk], [StatusID], [EnclosureID], [PduID], [KvmID], [SN], [WarrantyStartDate], [WarrantyEndDate], [VendorID], [VirtualCenter], [VMVersion], [VMClusterName], [BakServerName], [Comments]) VALUES (@PhysicalID, @ServerTypeID, @AssetNo, @UniqueNo, @Brand, @Model, @SiteCodeID, @Floors, @RackID, @PositionInRack, @iLOIP, @CPU, @RAM, @HardDisk, @StatusID, @EnclosureID, @PduID, @KvmID, @SN, @WarrantyStartDate, @WarrantyEndDate, @VendorID, @VirtualCenter, @VMVersion, @VMClusterName, @BakServerName, @Comments);
SELECT PhysicalID, ServerTypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, iLOIP, CPU, RAM, HardDisk, StatusID, EnclosureID, PduID, KvmID, SN, WarrantyStartDate, WarrantyEndDate, VendorID, VirtualCenter, VMVersion, VMClusterName, BakServerName, Comments FROM PhysicalMachineInfo WHERE (PhysicalID = @PhysicalID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@iLOIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VirtualCenter" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VMVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VMClusterName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BakServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT PhysicalID, ServerTypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, iLOIP, CPU, RAM, HardDisk, StatusID, EnclosureID, PduID, KvmID, SN, WarrantyStartDate, WarrantyEndDate, VendorID, VirtualCenter, VMVersion, VMClusterName, BakServerName, Comments FROM dbo.PhysicalMachineInfo</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[PhysicalMachineInfo] SET [PhysicalID] = @PhysicalID, [ServerTypeID] = @ServerTypeID, [AssetNo] = @AssetNo, [UniqueNo] = @UniqueNo, [Brand] = @Brand, [Model] = @Model, [SiteCodeID] = @SiteCodeID, [Floors] = @Floors, [RackID] = @RackID, [PositionInRack] = @PositionInRack, [iLOIP] = @iLOIP, [CPU] = @CPU, [RAM] = @RAM, [HardDisk] = @HardDisk, [StatusID] = @StatusID, [EnclosureID] = @EnclosureID, [PduID] = @PduID, [KvmID] = @KvmID, [SN] = @SN, [WarrantyStartDate] = @WarrantyStartDate, [WarrantyEndDate] = @WarrantyEndDate, [VendorID] = @VendorID, [VirtualCenter] = @VirtualCenter, [VMVersion] = @VMVersion, [VMClusterName] = @VMClusterName, [BakServerName] = @BakServerName, [Comments] = @Comments WHERE (([PhysicalID] = @Original_PhysicalID) AND ((@IsNull_ServerTypeID = 1 AND [ServerTypeID] IS NULL) OR ([ServerTypeID] = @Original_ServerTypeID)) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_UniqueNo = 1 AND [UniqueNo] IS NULL) OR ([UniqueNo] = @Original_UniqueNo)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_RackID = 1 AND [RackID] IS NULL) OR ([RackID] = @Original_RackID)) AND ((@IsNull_PositionInRack = 1 AND [PositionInRack] IS NULL) OR ([PositionInRack] = @Original_PositionInRack)) AND ((@IsNull_iLOIP = 1 AND [iLOIP] IS NULL) OR ([iLOIP] = @Original_iLOIP)) AND ((@IsNull_CPU = 1 AND [CPU] IS NULL) OR ([CPU] = @Original_CPU)) AND ((@IsNull_RAM = 1 AND [RAM] IS NULL) OR ([RAM] = @Original_RAM)) AND ((@IsNull_HardDisk = 1 AND [HardDisk] IS NULL) OR ([HardDisk] = @Original_HardDisk)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_EnclosureID = 1 AND [EnclosureID] IS NULL) OR ([EnclosureID] = @Original_EnclosureID)) AND ((@IsNull_PduID = 1 AND [PduID] IS NULL) OR ([PduID] = @Original_PduID)) AND ((@IsNull_KvmID = 1 AND [KvmID] IS NULL) OR ([KvmID] = @Original_KvmID)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)) AND ((@IsNull_VirtualCenter = 1 AND [VirtualCenter] IS NULL) OR ([VirtualCenter] = @Original_VirtualCenter)) AND ((@IsNull_VMVersion = 1 AND [VMVersion] IS NULL) OR ([VMVersion] = @Original_VMVersion)) AND ((@IsNull_VMClusterName = 1 AND [VMClusterName] IS NULL) OR ([VMClusterName] = @Original_VMClusterName)) AND ((@IsNull_BakServerName = 1 AND [BakServerName] IS NULL) OR ([BakServerName] = @Original_BakServerName)) AND ((@IsNull_Comments = 1 AND [Comments] IS NULL) OR ([Comments] = @Original_Comments)));
SELECT PhysicalID, ServerTypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, iLOIP, CPU, RAM, HardDisk, StatusID, EnclosureID, PduID, KvmID, SN, WarrantyStartDate, WarrantyEndDate, VendorID, VirtualCenter, VMVersion, VMClusterName, BakServerName, Comments FROM PhysicalMachineInfo WHERE (PhysicalID = @PhysicalID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@iLOIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VirtualCenter" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VMVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@VMClusterName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BakServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniqueNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionInRack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iLOIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_iLOIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="iLOIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RAM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HardDisk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_KvmID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="KvmID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VirtualCenter" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VirtualCenter" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VirtualCenter" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VMVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VMVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VMClusterName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_VMClusterName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="VMClusterName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BakServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BakServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BakServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Comments" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Comments" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="PhysicalID" DataSetColumn="PhysicalID" />
              <Mapping SourceColumn="ServerTypeID" DataSetColumn="ServerTypeID" />
              <Mapping SourceColumn="AssetNo" DataSetColumn="AssetNo" />
              <Mapping SourceColumn="UniqueNo" DataSetColumn="UniqueNo" />
              <Mapping SourceColumn="Brand" DataSetColumn="Brand" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="SiteCodeID" DataSetColumn="SiteCodeID" />
              <Mapping SourceColumn="Floors" DataSetColumn="Floors" />
              <Mapping SourceColumn="RackID" DataSetColumn="RackID" />
              <Mapping SourceColumn="PositionInRack" DataSetColumn="PositionInRack" />
              <Mapping SourceColumn="iLOIP" DataSetColumn="iLOIP" />
              <Mapping SourceColumn="CPU" DataSetColumn="CPU" />
              <Mapping SourceColumn="RAM" DataSetColumn="RAM" />
              <Mapping SourceColumn="HardDisk" DataSetColumn="HardDisk" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="EnclosureID" DataSetColumn="EnclosureID" />
              <Mapping SourceColumn="PduID" DataSetColumn="PduID" />
              <Mapping SourceColumn="KvmID" DataSetColumn="KvmID" />
              <Mapping SourceColumn="SN" DataSetColumn="SN" />
              <Mapping SourceColumn="WarrantyStartDate" DataSetColumn="WarrantyStartDate" />
              <Mapping SourceColumn="WarrantyEndDate" DataSetColumn="WarrantyEndDate" />
              <Mapping SourceColumn="VendorID" DataSetColumn="VendorID" />
              <Mapping SourceColumn="VirtualCenter" DataSetColumn="VirtualCenter" />
              <Mapping SourceColumn="VMVersion" DataSetColumn="VMVersion" />
              <Mapping SourceColumn="VMClusterName" DataSetColumn="VMClusterName" />
              <Mapping SourceColumn="BakServerName" DataSetColumn="BakServerName" />
              <Mapping SourceColumn="Comments" DataSetColumn="Comments" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbServerTableAdapter" GeneratorDataComponentClassName="tbServerTableAdapter" Name="tbServer" UserDataComponentName="tbServerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AssetManageConnectionString (Settings)" DbObjectName="AssetManage.dbo.tbServer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tbServer] WHERE (([ServerID] = @Original_ServerID) AND ((@IsNull_PhysicalID = 1 AND [PhysicalID] IS NULL) OR ([PhysicalID] = @Original_PhysicalID)) AND ((@IsNull_ServerName = 1 AND [ServerName] IS NULL) OR ([ServerName] = @Original_ServerName)) AND ((@IsNull_Alias = 1 AND [Alias] IS NULL) OR ([Alias] = @Original_Alias)) AND ((@IsNull_ServerIP = 1 AND [ServerIP] IS NULL) OR ([ServerIP] = @Original_ServerIP)) AND ((@IsNull_DomainID = 1 AND [DomainID] IS NULL) OR ([DomainID] = @Original_DomainID)) AND ((@IsNull_OSNameID = 1 AND [OSNameID] IS NULL) OR ([OSNameID] = @Original_OSNameID)) AND ((@IsNull_OSVersion = 1 AND [OSVersion] IS NULL) OR ([OSVersion] = @Original_OSVersion)) AND ((@IsNull_OSServicePackID = 1 AND [OSServicePackID] IS NULL) OR ([OSServicePackID] = @Original_OSServicePackID)) AND ((@IsNull_EnvironmentID = 1 AND [EnvironmentID] IS NULL) OR ([EnvironmentID] = @Original_EnvironmentID)) AND ((@IsNull_CPU = 1 AND [CPU] IS NULL) OR ([CPU] = @Original_CPU)) AND ((@IsNull_RAM = 1 AND [RAM] IS NULL) OR ([RAM] = @Original_RAM)) AND ((@IsNull_HardDisk = 1 AND [HardDisk] IS NULL) OR ([HardDisk] = @Original_HardDisk)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_ScomStatusID = 1 AND [ScomStatusID] IS NULL) OR ([ScomStatusID] = @Original_ScomStatusID)) AND ((@IsNull_PatchStatusID = 1 AND [PatchStatusID] IS NULL) OR ([PatchStatusID] = @Original_PatchStatusID)) AND ((@IsNull_CVCoverageID = 1 AND [CVCoverageID] IS NULL) OR ([CVCoverageID] = @Original_CVCoverageID)) AND ((@IsNull_AppCatalog = 1 AND [AppCatalog] IS NULL) OR ([AppCatalog] = @Original_AppCatalog)) AND ((@IsNull_HostingTypeID = 1 AND [HostingTypeID] IS NULL) OR ([HostingTypeID] = @Original_HostingTypeID)) AND ((@IsNull_AppSupportTeam = 1 AND [AppSupportTeam] IS NULL) OR ([AppSupportTeam] = @Original_AppSupportTeam)) AND ((@IsNull_BuID = 1 AND [BuID] IS NULL) OR ([BuID] = @Original_BuID)) AND ((@IsNull_BUdetails = 1 AND [BUdetails] IS NULL) OR ([BUdetails] = @Original_BUdetails)) AND ((@IsNull_IfCluster = 1 AND [IfCluster] IS NULL) OR ([IfCluster] = @Original_IfCluster)) AND ((@IsNull_ServerTypeID = 1 AND [ServerTypeID] IS NULL) OR ([ServerTypeID] = @Original_ServerTypeID)) AND ((@IsNull_ClusterID = 1 AND [ClusterID] IS NULL) OR ([ClusterID] = @Original_ClusterID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ServerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ServerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhysicalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ServerIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OSVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RAM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HardDisk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AppCatalog" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AppCatalog" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AppSupportTeam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AppSupportTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUdetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUdetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IfCluster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IfCluster" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tbServer] ([ServerID], [PhysicalID], [ServerName], [Alias], [ServerIP], [DomainID], [OSNameID], [OSVersion], [OSServicePackID], [EnvironmentID], [CPU], [RAM], [HardDisk], [StatusID], [ScomStatusID], [PatchStatusID], [CVCoverageID], [AppCatalog], [HostingTypeID], [AppSupportTeam], [BuID], [BUdetails], [IfCluster], [ServerTypeID], [ClusterID]) VALUES (@ServerID, @PhysicalID, @ServerName, @Alias, @ServerIP, @DomainID, @OSNameID, @OSVersion, @OSServicePackID, @EnvironmentID, @CPU, @RAM, @HardDisk, @StatusID, @ScomStatusID, @PatchStatusID, @CVCoverageID, @AppCatalog, @HostingTypeID, @AppSupportTeam, @BuID, @BUdetails, @IfCluster, @ServerTypeID, @ClusterID);
SELECT ServerID, PhysicalID, ServerName, Alias, ServerIP, DomainID, OSNameID, OSVersion, OSServicePackID, EnvironmentID, CPU, RAM, HardDisk, StatusID, ScomStatusID, PatchStatusID, CVCoverageID, AppCatalog, HostingTypeID, AppSupportTeam, BuID, BUdetails, IfCluster, ServerTypeID, ClusterID FROM tbServer WHERE (ServerID = @ServerID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ServerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ServerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ServerIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OSVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AppCatalog" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AppSupportTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUdetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IfCluster" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT ServerID, PhysicalID, ServerName, Alias, ServerIP, DomainID, OSNameID, OSVersion, OSServicePackID, EnvironmentID, CPU, RAM, HardDisk, StatusID, ScomStatusID, PatchStatusID, CVCoverageID, AppCatalog, HostingTypeID, AppSupportTeam, BuID, BUdetails, IfCluster, ServerTypeID, ClusterID FROM dbo.tbServer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tbServer] SET [ServerID] = @ServerID, [PhysicalID] = @PhysicalID, [ServerName] = @ServerName, [Alias] = @Alias, [ServerIP] = @ServerIP, [DomainID] = @DomainID, [OSNameID] = @OSNameID, [OSVersion] = @OSVersion, [OSServicePackID] = @OSServicePackID, [EnvironmentID] = @EnvironmentID, [CPU] = @CPU, [RAM] = @RAM, [HardDisk] = @HardDisk, [StatusID] = @StatusID, [ScomStatusID] = @ScomStatusID, [PatchStatusID] = @PatchStatusID, [CVCoverageID] = @CVCoverageID, [AppCatalog] = @AppCatalog, [HostingTypeID] = @HostingTypeID, [AppSupportTeam] = @AppSupportTeam, [BuID] = @BuID, [BUdetails] = @BUdetails, [IfCluster] = @IfCluster, [ServerTypeID] = @ServerTypeID, [ClusterID] = @ClusterID WHERE (([ServerID] = @Original_ServerID) AND ((@IsNull_PhysicalID = 1 AND [PhysicalID] IS NULL) OR ([PhysicalID] = @Original_PhysicalID)) AND ((@IsNull_ServerName = 1 AND [ServerName] IS NULL) OR ([ServerName] = @Original_ServerName)) AND ((@IsNull_Alias = 1 AND [Alias] IS NULL) OR ([Alias] = @Original_Alias)) AND ((@IsNull_ServerIP = 1 AND [ServerIP] IS NULL) OR ([ServerIP] = @Original_ServerIP)) AND ((@IsNull_DomainID = 1 AND [DomainID] IS NULL) OR ([DomainID] = @Original_DomainID)) AND ((@IsNull_OSNameID = 1 AND [OSNameID] IS NULL) OR ([OSNameID] = @Original_OSNameID)) AND ((@IsNull_OSVersion = 1 AND [OSVersion] IS NULL) OR ([OSVersion] = @Original_OSVersion)) AND ((@IsNull_OSServicePackID = 1 AND [OSServicePackID] IS NULL) OR ([OSServicePackID] = @Original_OSServicePackID)) AND ((@IsNull_EnvironmentID = 1 AND [EnvironmentID] IS NULL) OR ([EnvironmentID] = @Original_EnvironmentID)) AND ((@IsNull_CPU = 1 AND [CPU] IS NULL) OR ([CPU] = @Original_CPU)) AND ((@IsNull_RAM = 1 AND [RAM] IS NULL) OR ([RAM] = @Original_RAM)) AND ((@IsNull_HardDisk = 1 AND [HardDisk] IS NULL) OR ([HardDisk] = @Original_HardDisk)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_ScomStatusID = 1 AND [ScomStatusID] IS NULL) OR ([ScomStatusID] = @Original_ScomStatusID)) AND ((@IsNull_PatchStatusID = 1 AND [PatchStatusID] IS NULL) OR ([PatchStatusID] = @Original_PatchStatusID)) AND ((@IsNull_CVCoverageID = 1 AND [CVCoverageID] IS NULL) OR ([CVCoverageID] = @Original_CVCoverageID)) AND ((@IsNull_AppCatalog = 1 AND [AppCatalog] IS NULL) OR ([AppCatalog] = @Original_AppCatalog)) AND ((@IsNull_HostingTypeID = 1 AND [HostingTypeID] IS NULL) OR ([HostingTypeID] = @Original_HostingTypeID)) AND ((@IsNull_AppSupportTeam = 1 AND [AppSupportTeam] IS NULL) OR ([AppSupportTeam] = @Original_AppSupportTeam)) AND ((@IsNull_BuID = 1 AND [BuID] IS NULL) OR ([BuID] = @Original_BuID)) AND ((@IsNull_BUdetails = 1 AND [BUdetails] IS NULL) OR ([BUdetails] = @Original_BUdetails)) AND ((@IsNull_IfCluster = 1 AND [IfCluster] IS NULL) OR ([IfCluster] = @Original_IfCluster)) AND ((@IsNull_ServerTypeID = 1 AND [ServerTypeID] IS NULL) OR ([ServerTypeID] = @Original_ServerTypeID)) AND ((@IsNull_ClusterID = 1 AND [ClusterID] IS NULL) OR ([ClusterID] = @Original_ClusterID)));
SELECT ServerID, PhysicalID, ServerName, Alias, ServerIP, DomainID, OSNameID, OSVersion, OSServicePackID, EnvironmentID, CPU, RAM, HardDisk, StatusID, ScomStatusID, PatchStatusID, CVCoverageID, AppCatalog, HostingTypeID, AppSupportTeam, BuID, BUdetails, IfCluster, ServerTypeID, ClusterID FROM tbServer WHERE (ServerID = @ServerID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@ServerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ServerID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ServerIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@OSVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AppCatalog" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AppSupportTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@BUdetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@IfCluster" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_ServerID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="ServerID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PhysicalID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_PhysicalID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="PhysicalID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ServerName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Alias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Alias" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Alias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ServerIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ServerIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_DomainID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DomainID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OSNameID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSNameID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSVersion" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_OSVersion" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="OSVersion" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OSServicePackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OSServicePackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnvironmentID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnvironmentID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CPU" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CPU" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CPU" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RAM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_RAM" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="RAM" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HardDisk" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_HardDisk" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="HardDisk" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ScomStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ScomStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PatchStatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PatchStatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CVCoverageID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CVCoverageID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AppCatalog" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AppCatalog" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppCatalog" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AppSupportTeam" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AppSupportTeam" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AppSupportTeam" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_BuID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BuID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_BUdetails" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_BUdetails" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="BUdetails" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IfCluster" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_IfCluster" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="IfCluster" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ServerTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ServerTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ClusterID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ClusterID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="ServerID" DataSetColumn="ServerID" />
              <Mapping SourceColumn="PhysicalID" DataSetColumn="PhysicalID" />
              <Mapping SourceColumn="ServerName" DataSetColumn="ServerName" />
              <Mapping SourceColumn="Alias" DataSetColumn="Alias" />
              <Mapping SourceColumn="ServerIP" DataSetColumn="ServerIP" />
              <Mapping SourceColumn="DomainID" DataSetColumn="DomainID" />
              <Mapping SourceColumn="OSNameID" DataSetColumn="OSNameID" />
              <Mapping SourceColumn="OSVersion" DataSetColumn="OSVersion" />
              <Mapping SourceColumn="OSServicePackID" DataSetColumn="OSServicePackID" />
              <Mapping SourceColumn="EnvironmentID" DataSetColumn="EnvironmentID" />
              <Mapping SourceColumn="CPU" DataSetColumn="CPU" />
              <Mapping SourceColumn="RAM" DataSetColumn="RAM" />
              <Mapping SourceColumn="HardDisk" DataSetColumn="HardDisk" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="ScomStatusID" DataSetColumn="ScomStatusID" />
              <Mapping SourceColumn="PatchStatusID" DataSetColumn="PatchStatusID" />
              <Mapping SourceColumn="CVCoverageID" DataSetColumn="CVCoverageID" />
              <Mapping SourceColumn="AppCatalog" DataSetColumn="AppCatalog" />
              <Mapping SourceColumn="HostingTypeID" DataSetColumn="HostingTypeID" />
              <Mapping SourceColumn="AppSupportTeam" DataSetColumn="AppSupportTeam" />
              <Mapping SourceColumn="BuID" DataSetColumn="BuID" />
              <Mapping SourceColumn="BUdetails" DataSetColumn="BUdetails" />
              <Mapping SourceColumn="IfCluster" DataSetColumn="IfCluster" />
              <Mapping SourceColumn="ServerTypeID" DataSetColumn="ServerTypeID" />
              <Mapping SourceColumn="ClusterID" DataSetColumn="ClusterID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbNetworkTableAdapter" GeneratorDataComponentClassName="tbNetworkTableAdapter" Name="tbNetwork" UserDataComponentName="tbNetworkTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AssetManageConnectionString (Settings)" DbObjectName="AssetManage.dbo.tbNetwork" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tbNetwork] WHERE (([NetworkID] = @Original_NetworkID) AND ((@IsNull_TypeID = 1 AND [TypeID] IS NULL) OR ([TypeID] = @Original_TypeID)) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_UniqueNo = 1 AND [UniqueNo] IS NULL) OR ([UniqueNo] = @Original_UniqueNo)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_RackID = 1 AND [RackID] IS NULL) OR ([RackID] = @Original_RackID)) AND ((@IsNull_PositionInRack = 1 AND [PositionInRack] IS NULL) OR ([PositionInRack] = @Original_PositionInRack)) AND ((@IsNull_ManageIP = 1 AND [ManageIP] IS NULL) OR ([ManageIP] = @Original_ManageIP)) AND ((@IsNull_Capacity100Mbps = 1 AND [Capacity100Mbps] IS NULL) OR ([Capacity100Mbps] = @Original_Capacity100Mbps)) AND ((@IsNull_Capacity1Gbps = 1 AND [Capacity1Gbps] IS NULL) OR ([Capacity1Gbps] = @Original_Capacity1Gbps)) AND ((@IsNull_Capacity10Gbps = 1 AND [Capacity10Gbps] IS NULL) OR ([Capacity10Gbps] = @Original_Capacity10Gbps)) AND ((@IsNull_UplinkInfo = 1 AND [UplinkInfo] IS NULL) OR ([UplinkInfo] = @Original_UplinkInfo)) AND ((@IsNull_HostingTypeID = 1 AND [HostingTypeID] IS NULL) OR ([HostingTypeID] = @Original_HostingTypeID)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_PduID = 1 AND [PduID] IS NULL) OR ([PduID] = @Original_PduID)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NetworkID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NetworkID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniqueNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionInRack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ManageIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ManageIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity100Mbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity100Mbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity1Gbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity1Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity10Gbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity10Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UplinkInfo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UplinkInfo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tbNetwork] ([NetworkID], [TypeID], [AssetNo], [UniqueNo], [Brand], [Model], [SiteCodeID], [Floors], [RackID], [PositionInRack], [ManageIP], [Capacity100Mbps], [Capacity1Gbps], [Capacity10Gbps], [UplinkInfo], [HostingTypeID], [StatusID], [PduID], [SN], [WarrantyStartDate], [WarrantyEndDate], [VendorID]) VALUES (@NetworkID, @TypeID, @AssetNo, @UniqueNo, @Brand, @Model, @SiteCodeID, @Floors, @RackID, @PositionInRack, @ManageIP, @Capacity100Mbps, @Capacity1Gbps, @Capacity10Gbps, @UplinkInfo, @HostingTypeID, @StatusID, @PduID, @SN, @WarrantyStartDate, @WarrantyEndDate, @VendorID);
SELECT NetworkID, TypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, ManageIP, Capacity100Mbps, Capacity1Gbps, Capacity10Gbps, UplinkInfo, HostingTypeID, StatusID, PduID, SN, WarrantyStartDate, WarrantyEndDate, VendorID FROM tbNetwork WHERE (NetworkID = @NetworkID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NetworkID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NetworkID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ManageIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity100Mbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity1Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity10Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UplinkInfo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT NetworkID, TypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, ManageIP, Capacity100Mbps, Capacity1Gbps, Capacity10Gbps, UplinkInfo, HostingTypeID, StatusID, PduID, SN, WarrantyStartDate, WarrantyEndDate, VendorID FROM dbo.tbNetwork</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tbNetwork] SET [NetworkID] = @NetworkID, [TypeID] = @TypeID, [AssetNo] = @AssetNo, [UniqueNo] = @UniqueNo, [Brand] = @Brand, [Model] = @Model, [SiteCodeID] = @SiteCodeID, [Floors] = @Floors, [RackID] = @RackID, [PositionInRack] = @PositionInRack, [ManageIP] = @ManageIP, [Capacity100Mbps] = @Capacity100Mbps, [Capacity1Gbps] = @Capacity1Gbps, [Capacity10Gbps] = @Capacity10Gbps, [UplinkInfo] = @UplinkInfo, [HostingTypeID] = @HostingTypeID, [StatusID] = @StatusID, [PduID] = @PduID, [SN] = @SN, [WarrantyStartDate] = @WarrantyStartDate, [WarrantyEndDate] = @WarrantyEndDate, [VendorID] = @VendorID WHERE (([NetworkID] = @Original_NetworkID) AND ((@IsNull_TypeID = 1 AND [TypeID] IS NULL) OR ([TypeID] = @Original_TypeID)) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_UniqueNo = 1 AND [UniqueNo] IS NULL) OR ([UniqueNo] = @Original_UniqueNo)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_Model = 1 AND [Model] IS NULL) OR ([Model] = @Original_Model)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_RackID = 1 AND [RackID] IS NULL) OR ([RackID] = @Original_RackID)) AND ((@IsNull_PositionInRack = 1 AND [PositionInRack] IS NULL) OR ([PositionInRack] = @Original_PositionInRack)) AND ((@IsNull_ManageIP = 1 AND [ManageIP] IS NULL) OR ([ManageIP] = @Original_ManageIP)) AND ((@IsNull_Capacity100Mbps = 1 AND [Capacity100Mbps] IS NULL) OR ([Capacity100Mbps] = @Original_Capacity100Mbps)) AND ((@IsNull_Capacity1Gbps = 1 AND [Capacity1Gbps] IS NULL) OR ([Capacity1Gbps] = @Original_Capacity1Gbps)) AND ((@IsNull_Capacity10Gbps = 1 AND [Capacity10Gbps] IS NULL) OR ([Capacity10Gbps] = @Original_Capacity10Gbps)) AND ((@IsNull_UplinkInfo = 1 AND [UplinkInfo] IS NULL) OR ([UplinkInfo] = @Original_UplinkInfo)) AND ((@IsNull_HostingTypeID = 1 AND [HostingTypeID] IS NULL) OR ([HostingTypeID] = @Original_HostingTypeID)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_PduID = 1 AND [PduID] IS NULL) OR ([PduID] = @Original_PduID)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)));
SELECT NetworkID, TypeID, AssetNo, UniqueNo, Brand, Model, SiteCodeID, Floors, RackID, PositionInRack, ManageIP, Capacity100Mbps, Capacity1Gbps, Capacity10Gbps, UplinkInfo, HostingTypeID, StatusID, PduID, SN, WarrantyStartDate, WarrantyEndDate, VendorID FROM tbNetwork WHERE (NetworkID = @NetworkID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@NetworkID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NetworkID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ManageIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity100Mbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity1Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Capacity10Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UplinkInfo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Guid" Direction="Input" ParameterName="@Original_NetworkID" Precision="0" ProviderType="UniqueIdentifier" Scale="0" Size="0" SourceColumn="NetworkID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UniqueNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UniqueNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UniqueNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Model" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Model" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Model" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RackID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RackID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PositionInRack" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PositionInRack" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PositionInRack" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ManageIP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ManageIP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ManageIP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity100Mbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity100Mbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity100Mbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity1Gbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity1Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity1Gbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Capacity10Gbps" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Capacity10Gbps" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Capacity10Gbps" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UplinkInfo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UplinkInfo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UplinkInfo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_HostingTypeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="HostingTypeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_PduID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PduID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="NetworkID" DataSetColumn="NetworkID" />
              <Mapping SourceColumn="TypeID" DataSetColumn="TypeID" />
              <Mapping SourceColumn="AssetNo" DataSetColumn="AssetNo" />
              <Mapping SourceColumn="UniqueNo" DataSetColumn="UniqueNo" />
              <Mapping SourceColumn="Brand" DataSetColumn="Brand" />
              <Mapping SourceColumn="Model" DataSetColumn="Model" />
              <Mapping SourceColumn="SiteCodeID" DataSetColumn="SiteCodeID" />
              <Mapping SourceColumn="Floors" DataSetColumn="Floors" />
              <Mapping SourceColumn="RackID" DataSetColumn="RackID" />
              <Mapping SourceColumn="PositionInRack" DataSetColumn="PositionInRack" />
              <Mapping SourceColumn="ManageIP" DataSetColumn="ManageIP" />
              <Mapping SourceColumn="Capacity100Mbps" DataSetColumn="Capacity100Mbps" />
              <Mapping SourceColumn="Capacity1Gbps" DataSetColumn="Capacity1Gbps" />
              <Mapping SourceColumn="Capacity10Gbps" DataSetColumn="Capacity10Gbps" />
              <Mapping SourceColumn="UplinkInfo" DataSetColumn="UplinkInfo" />
              <Mapping SourceColumn="HostingTypeID" DataSetColumn="HostingTypeID" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="PduID" DataSetColumn="PduID" />
              <Mapping SourceColumn="SN" DataSetColumn="SN" />
              <Mapping SourceColumn="WarrantyStartDate" DataSetColumn="WarrantyStartDate" />
              <Mapping SourceColumn="WarrantyEndDate" DataSetColumn="WarrantyEndDate" />
              <Mapping SourceColumn="VendorID" DataSetColumn="VendorID" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbEnclosureTableAdapter" GeneratorDataComponentClassName="tbEnclosureTableAdapter" Name="tbEnclosure" UserDataComponentName="tbEnclosureTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="AssetManageConnectionString (Settings)" DbObjectName="AssetManage.dbo.tbEnclosure" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tbEnclosure] WHERE (([EnclosureID] = @Original_EnclosureID) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_EnclosureName = 1 AND [EnclosureName] IS NULL) OR ([EnclosureName] = @Original_EnclosureName)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_UUID = 1 AND [UUID] IS NULL) OR ([UUID] = @Original_UUID)) AND ((@IsNull_PartNumber = 1 AND [PartNumber] IS NULL) OR ([PartNumber] = @Original_PartNumber)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnclosureName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EnclosureName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UUID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PartNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PartNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tbEnclosure] ([AssetNo], [EnclosureName], [StatusID], [Brand], [SiteCodeID], [Floors], [SN], [UUID], [PartNumber], [WarrantyStartDate], [WarrantyEndDate], [VendorID]) VALUES (@AssetNo, @EnclosureName, @StatusID, @Brand, @SiteCodeID, @Floors, @SN, @UUID, @PartNumber, @WarrantyStartDate, @WarrantyEndDate, @VendorID);
SELECT EnclosureID, AssetNo, EnclosureName, StatusID, Brand, SiteCodeID, Floors, SN, UUID, PartNumber, WarrantyStartDate, WarrantyEndDate, VendorID FROM tbEnclosure WHERE (EnclosureID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EnclosureName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UUID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PartNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT EnclosureID, AssetNo, EnclosureName, StatusID, Brand, SiteCodeID, Floors, SN, UUID, PartNumber, WarrantyStartDate, WarrantyEndDate, VendorID FROM dbo.tbEnclosure</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tbEnclosure] SET [AssetNo] = @AssetNo, [EnclosureName] = @EnclosureName, [StatusID] = @StatusID, [Brand] = @Brand, [SiteCodeID] = @SiteCodeID, [Floors] = @Floors, [SN] = @SN, [UUID] = @UUID, [PartNumber] = @PartNumber, [WarrantyStartDate] = @WarrantyStartDate, [WarrantyEndDate] = @WarrantyEndDate, [VendorID] = @VendorID WHERE (([EnclosureID] = @Original_EnclosureID) AND ((@IsNull_AssetNo = 1 AND [AssetNo] IS NULL) OR ([AssetNo] = @Original_AssetNo)) AND ((@IsNull_EnclosureName = 1 AND [EnclosureName] IS NULL) OR ([EnclosureName] = @Original_EnclosureName)) AND ((@IsNull_StatusID = 1 AND [StatusID] IS NULL) OR ([StatusID] = @Original_StatusID)) AND ((@IsNull_Brand = 1 AND [Brand] IS NULL) OR ([Brand] = @Original_Brand)) AND ((@IsNull_SiteCodeID = 1 AND [SiteCodeID] IS NULL) OR ([SiteCodeID] = @Original_SiteCodeID)) AND ((@IsNull_Floors = 1 AND [Floors] IS NULL) OR ([Floors] = @Original_Floors)) AND ((@IsNull_SN = 1 AND [SN] IS NULL) OR ([SN] = @Original_SN)) AND ((@IsNull_UUID = 1 AND [UUID] IS NULL) OR ([UUID] = @Original_UUID)) AND ((@IsNull_PartNumber = 1 AND [PartNumber] IS NULL) OR ([PartNumber] = @Original_PartNumber)) AND ((@IsNull_WarrantyStartDate = 1 AND [WarrantyStartDate] IS NULL) OR ([WarrantyStartDate] = @Original_WarrantyStartDate)) AND ((@IsNull_WarrantyEndDate = 1 AND [WarrantyEndDate] IS NULL) OR ([WarrantyEndDate] = @Original_WarrantyEndDate)) AND ((@IsNull_VendorID = 1 AND [VendorID] IS NULL) OR ([VendorID] = @Original_VendorID)));
SELECT EnclosureID, AssetNo, EnclosureName, StatusID, Brand, SiteCodeID, Floors, SN, UUID, PartNumber, WarrantyStartDate, WarrantyEndDate, VendorID FROM tbEnclosure WHERE (EnclosureID = @EnclosureID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@EnclosureName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@UUID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PartNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AssetNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_AssetNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="AssetNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EnclosureName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_EnclosureName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="EnclosureName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_StatusID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StatusID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Brand" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Brand" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Brand" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SiteCodeID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SiteCodeID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Floors" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Floors" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Floors" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SN" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_UUID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_UUID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="UUID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PartNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PartNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PartNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyStartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyStartDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyStartDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WarrantyEndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_WarrantyEndDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="WarrantyEndDate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_VendorID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="VendorID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="EnclosureID" ColumnName="EnclosureID" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@EnclosureID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="EnclosureID" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="EnclosureID" DataSetColumn="EnclosureID" />
              <Mapping SourceColumn="AssetNo" DataSetColumn="AssetNo" />
              <Mapping SourceColumn="EnclosureName" DataSetColumn="EnclosureName" />
              <Mapping SourceColumn="StatusID" DataSetColumn="StatusID" />
              <Mapping SourceColumn="Brand" DataSetColumn="Brand" />
              <Mapping SourceColumn="SiteCodeID" DataSetColumn="SiteCodeID" />
              <Mapping SourceColumn="Floors" DataSetColumn="Floors" />
              <Mapping SourceColumn="SN" DataSetColumn="SN" />
              <Mapping SourceColumn="UUID" DataSetColumn="UUID" />
              <Mapping SourceColumn="PartNumber" DataSetColumn="PartNumber" />
              <Mapping SourceColumn="WarrantyStartDate" DataSetColumn="WarrantyStartDate" />
              <Mapping SourceColumn="WarrantyEndDate" DataSetColumn="WarrantyEndDate" />
              <Mapping SourceColumn="VendorID" DataSetColumn="VendorID" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="Asset" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="Asset" msprop:Generator_UserDSName="Asset">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="IPRange" msprop:Generator_UserTableName="IPRange" msprop:Generator_RowEvArgName="IPRangeRowChangeEvent" msprop:Generator_TableVarName="tableIPRange" msprop:Generator_TablePropName="IPRange" msprop:Generator_RowDeletingName="IPRangeRowDeleting" msprop:Generator_RowChangingName="IPRangeRowChanging" msprop:Generator_RowDeletedName="IPRangeRowDeleted" msprop:Generator_TableClassName="IPRangeDataTable" msprop:Generator_RowChangedName="IPRangeRowChanged" msprop:Generator_RowEvHandlerName="IPRangeRowChangeEventHandler" msprop:Generator_RowClassName="IPRangeRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IPRangeID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnIPRangeID" msprop:Generator_ColumnPropNameInRow="IPRangeID" msprop:Generator_ColumnPropNameInTable="IPRangeIDColumn" msprop:Generator_UserColumnName="IPRangeID" type="xs:string" />
              <xs:element name="IPRange" msprop:Generator_ColumnVarNameInTable="columnIPRange" msprop:Generator_ColumnPropNameInRow="IPRange" msprop:Generator_ColumnPropNameInTable="IPRangeColumn" msprop:Generator_UserColumnName="IPRange" type="xs:string" minOccurs="0" />
              <xs:element name="StartIP" msprop:Generator_ColumnVarNameInTable="columnStartIP" msprop:Generator_ColumnPropNameInRow="StartIP" msprop:Generator_ColumnPropNameInTable="StartIPColumn" msprop:Generator_UserColumnName="StartIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EndIP" msprop:Generator_ColumnVarNameInTable="columnEndIP" msprop:Generator_ColumnPropNameInRow="EndIP" msprop:Generator_ColumnPropNameInTable="EndIPColumn" msprop:Generator_UserColumnName="EndIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IPType" msprop:Generator_ColumnVarNameInTable="columnIPType" msprop:Generator_ColumnPropNameInRow="IPType" msprop:Generator_ColumnPropNameInTable="IPTypeColumn" msprop:Generator_UserColumnName="IPType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="SiteCodeInfo" msprop:Generator_UserTableName="SiteCodeInfo" msprop:Generator_RowEvArgName="SiteCodeInfoRowChangeEvent" msprop:Generator_TableVarName="tableSiteCodeInfo" msprop:Generator_TablePropName="SiteCodeInfo" msprop:Generator_RowDeletingName="SiteCodeInfoRowDeleting" msprop:Generator_RowChangingName="SiteCodeInfoRowChanging" msprop:Generator_RowDeletedName="SiteCodeInfoRowDeleted" msprop:Generator_TableClassName="SiteCodeInfoDataTable" msprop:Generator_RowChangedName="SiteCodeInfoRowChanged" msprop:Generator_RowEvHandlerName="SiteCodeInfoRowChangeEventHandler" msprop:Generator_RowClassName="SiteCodeInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="SiteCodeID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" type="xs:string" />
              <xs:element name="SiteCode" msprop:Generator_ColumnVarNameInTable="columnSiteCode" msprop:Generator_ColumnPropNameInRow="SiteCode" msprop:Generator_ColumnPropNameInTable="SiteCodeColumn" msprop:Generator_UserColumnName="SiteCode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DBInstanceInfo" msprop:Generator_UserTableName="DBInstanceInfo" msprop:Generator_RowEvArgName="DBInstanceInfoRowChangeEvent" msprop:Generator_TableVarName="tableDBInstanceInfo" msprop:Generator_TablePropName="DBInstanceInfo" msprop:Generator_RowDeletingName="DBInstanceInfoRowDeleting" msprop:Generator_RowChangingName="DBInstanceInfoRowChanging" msprop:Generator_RowDeletedName="DBInstanceInfoRowDeleted" msprop:Generator_TableClassName="DBInstanceInfoDataTable" msprop:Generator_RowChangedName="DBInstanceInfoRowChanged" msprop:Generator_RowEvHandlerName="DBInstanceInfoRowChangeEventHandler" msprop:Generator_RowClassName="DBInstanceInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DBInstanceID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnDBInstanceID" msprop:Generator_ColumnPropNameInRow="DBInstanceID" msprop:Generator_ColumnPropNameInTable="DBInstanceIDColumn" msprop:Generator_UserColumnName="DBInstanceID" type="xs:string" />
              <xs:element name="ServerID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnServerID" msprop:Generator_ColumnPropNameInRow="ServerID" msprop:Generator_ColumnPropNameInTable="ServerIDColumn" msprop:Generator_UserColumnName="ServerID" type="xs:string" minOccurs="0" />
              <xs:element name="FullInstanceName" msprop:Generator_ColumnVarNameInTable="columnFullInstanceName" msprop:Generator_ColumnPropNameInRow="FullInstanceName" msprop:Generator_ColumnPropNameInTable="FullInstanceNameColumn" msprop:Generator_UserColumnName="FullInstanceName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBTypeID" msdata:Caption="DBType" msprop:Generator_ColumnVarNameInTable="columnDBTypeID" msprop:Generator_ColumnPropNameInRow="DBTypeID" msprop:Generator_ColumnPropNameInTable="DBTypeIDColumn" msprop:Generator_UserColumnName="DBTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="DBVersion" msprop:Generator_ColumnVarNameInTable="columnDBVersion" msprop:Generator_ColumnPropNameInRow="DBVersion" msprop:Generator_ColumnPropNameInTable="DBVersionColumn" msprop:Generator_UserColumnName="DBVersion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBServicePack" msprop:Generator_ColumnVarNameInTable="columnDBServicePack" msprop:Generator_ColumnPropNameInRow="DBServicePack" msprop:Generator_ColumnPropNameInTable="DBServicePackColumn" msprop:Generator_UserColumnName="DBServicePack" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AuthenticationMode" msprop:Generator_ColumnVarNameInTable="columnAuthenticationMode" msprop:Generator_ColumnPropNameInRow="AuthenticationMode" msprop:Generator_ColumnPropNameInTable="AuthenticationModeColumn" msprop:Generator_UserColumnName="AuthenticationMode" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="SQLNetworkName" msprop:Generator_ColumnVarNameInTable="columnSQLNetworkName" msprop:Generator_ColumnPropNameInRow="SQLNetworkName" msprop:Generator_ColumnPropNameInTable="SQLNetworkNameColumn" msprop:Generator_UserColumnName="SQLNetworkName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SQLNetworkIP" msprop:Generator_ColumnVarNameInTable="columnSQLNetworkIP" msprop:Generator_ColumnPropNameInRow="SQLNetworkIP" msprop:Generator_ColumnPropNameInTable="SQLNetworkIPColumn" msprop:Generator_UserColumnName="SQLNetworkIP" type="xs:string" minOccurs="0" />
              <xs:element name="ClusterID" msprop:Generator_ColumnVarNameInTable="columnClusterID" msprop:Generator_ColumnPropNameInRow="ClusterID" msprop:Generator_ColumnPropNameInTable="ClusterIDColumn" msprop:Generator_UserColumnName="ClusterID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="DatabaseInfo" msprop:Generator_UserTableName="DatabaseInfo" msprop:Generator_RowEvArgName="DatabaseInfoRowChangeEvent" msprop:Generator_TableVarName="tableDatabaseInfo" msprop:Generator_TablePropName="DatabaseInfo" msprop:Generator_RowDeletingName="DatabaseInfoRowDeleting" msprop:Generator_RowChangingName="DatabaseInfoRowChanging" msprop:Generator_RowDeletedName="DatabaseInfoRowDeleted" msprop:Generator_TableClassName="DatabaseInfoDataTable" msprop:Generator_RowChangedName="DatabaseInfoRowChanged" msprop:Generator_RowEvHandlerName="DatabaseInfoRowChangeEventHandler" msprop:Generator_RowClassName="DatabaseInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="DatabaseID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnDatabaseID" msprop:Generator_ColumnPropNameInRow="DatabaseID" msprop:Generator_ColumnPropNameInTable="DatabaseIDColumn" msprop:Generator_UserColumnName="DatabaseID" type="xs:string" />
              <xs:element name="DBInstanceID" msprop:Generator_ColumnVarNameInTable="columnDBInstanceID" msprop:Generator_ColumnPropNameInRow="DBInstanceID" msprop:Generator_ColumnPropNameInTable="DBInstanceIDColumn" msprop:Generator_UserColumnName="DBInstanceID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBName" msprop:Generator_ColumnVarNameInTable="columnDBName" msprop:Generator_ColumnPropNameInRow="DBName" msprop:Generator_ColumnPropNameInTable="DBNameColumn" msprop:Generator_UserColumnName="DBName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBSize" msprop:Generator_ColumnVarNameInTable="columnDBSize" msprop:Generator_ColumnPropNameInRow="DBSize" msprop:Generator_ColumnPropNameInTable="DBSizeColumn" msprop:Generator_UserColumnName="DBSize" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UnallocatedSpace" msprop:Generator_ColumnVarNameInTable="columnUnallocatedSpace" msprop:Generator_ColumnPropNameInRow="UnallocatedSpace" msprop:Generator_ColumnPropNameInTable="UnallocatedSpaceColumn" msprop:Generator_UserColumnName="UnallocatedSpace" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LogSize" msprop:Generator_ColumnVarNameInTable="columnLogSize" msprop:Generator_ColumnPropNameInRow="LogSize" msprop:Generator_ColumnPropNameInTable="LogSizeColumn" msprop:Generator_UserColumnName="LogSize" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LogSpaceUsedPercent" msprop:Generator_ColumnVarNameInTable="columnLogSpaceUsedPercent" msprop:Generator_ColumnPropNameInRow="LogSpaceUsedPercent" msprop:Generator_ColumnPropNameInTable="LogSpaceUsedPercentColumn" msprop:Generator_UserColumnName="LogSpaceUsedPercent" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataAutogrowth" msprop:Generator_ColumnVarNameInTable="columnDataAutogrowth" msprop:Generator_ColumnPropNameInRow="DataAutogrowth" msprop:Generator_ColumnPropNameInTable="DataAutogrowthColumn" msprop:Generator_UserColumnName="DataAutogrowth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LogAutogrowth" msprop:Generator_ColumnVarNameInTable="columnLogAutogrowth" msprop:Generator_ColumnPropNameInRow="LogAutogrowth" msprop:Generator_ColumnPropNameInTable="LogAutogrowthColumn" msprop:Generator_UserColumnName="LogAutogrowth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="RecoveryModel" msprop:Generator_ColumnVarNameInTable="columnRecoveryModel" msprop:Generator_ColumnPropNameInRow="RecoveryModel" msprop:Generator_ColumnPropNameInTable="RecoveryModelColumn" msprop:Generator_UserColumnName="RecoveryModel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBOwner" msprop:Generator_ColumnVarNameInTable="columnDBOwner" msprop:Generator_ColumnPropNameInRow="DBOwner" msprop:Generator_ColumnPropNameInTable="DBOwnerColumn" msprop:Generator_UserColumnName="DBOwner" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBCreated" msprop:Generator_ColumnVarNameInTable="columnDBCreated" msprop:Generator_ColumnPropNameInRow="DBCreated" msprop:Generator_ColumnPropNameInTable="DBCreatedColumn" msprop:Generator_UserColumnName="DBCreated" type="xs:dateTime" minOccurs="0" />
              <xs:element name="CVCoverageID" msprop:Generator_ColumnVarNameInTable="columnCVCoverageID" msprop:Generator_ColumnPropNameInRow="CVCoverageID" msprop:Generator_ColumnPropNameInTable="CVCoverageIDColumn" msprop:Generator_UserColumnName="CVCoverageID" type="xs:int" minOccurs="0" />
              <xs:element name="Application" msprop:Generator_ColumnVarNameInTable="columnApplication" msprop:Generator_ColumnPropNameInRow="Application" msprop:Generator_ColumnPropNameInTable="ApplicationColumn" msprop:Generator_UserColumnName="Application" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DBSupportTeam" msprop:Generator_ColumnVarNameInTable="columnDBSupportTeam" msprop:Generator_ColumnPropNameInRow="DBSupportTeam" msprop:Generator_ColumnPropNameInTable="DBSupportTeamColumn" msprop:Generator_UserColumnName="DBSupportTeam" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="ClusterServerInfo" msprop:Generator_TableClassName="ClusterServerInfoDataTable" msprop:Generator_RowEvArgName="ClusterServerInfoRowChangeEvent" msprop:Generator_TableVarName="tableClusterServerInfo" msprop:Generator_TablePropName="ClusterServerInfo" msprop:Generator_RowDeletingName="ClusterServerInfoRowDeleting" msprop:Generator_UserTableName="ClusterServerInfo" msprop:Generator_RowChangingName="ClusterServerInfoRowChanging" msprop:Generator_RowDeletedName="ClusterServerInfoRowDeleted" msprop:Generator_RowChangedName="ClusterServerInfoRowChanged" msprop:Generator_RowEvHandlerName="ClusterServerInfoRowChangeEventHandler" msprop:Generator_RowClassName="ClusterServerInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ClusterID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnClusterID" msprop:Generator_ColumnPropNameInRow="ClusterID" msprop:Generator_ColumnPropNameInTable="ClusterIDColumn" msprop:Generator_UserColumnName="ClusterID" type="xs:string" />
              <xs:element name="ClusterType" msprop:Generator_ColumnVarNameInTable="columnClusterType" msprop:Generator_ColumnPropNameInRow="ClusterType" msprop:Generator_ColumnPropNameInTable="ClusterTypeColumn" msprop:Generator_UserColumnName="ClusterType" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClusterName" msprop:Generator_ColumnVarNameInTable="columnClusterName" msprop:Generator_ColumnPropNameInRow="ClusterName" msprop:Generator_ColumnPropNameInTable="ClusterNameColumn" msprop:Generator_UserColumnName="ClusterName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ClusterIP" msprop:Generator_ColumnVarNameInTable="columnClusterIP" msprop:Generator_ColumnPropNameInRow="ClusterIP" msprop:Generator_ColumnPropNameInTable="ClusterIPColumn" msprop:Generator_UserColumnName="ClusterIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SystemNodeID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnSystemNodeID" msprop:Generator_ColumnPropNameInRow="SystemNodeID" msprop:Generator_ColumnPropNameInTable="SystemNodeIDColumn" msprop:Generator_UserColumnName="SystemNodeID" type="xs:string" minOccurs="0" />
              <xs:element name="ResourceGroup" msprop:Generator_ColumnVarNameInTable="columnResourceGroup" msprop:Generator_ColumnPropNameInRow="ResourceGroup" msprop:Generator_ColumnPropNameInTable="ResourceGroupColumn" msprop:Generator_UserColumnName="ResourceGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NLBModeID" msprop:Generator_ColumnVarNameInTable="columnNLBModeID" msprop:Generator_ColumnPropNameInRow="NLBModeID" msprop:Generator_ColumnPropNameInTable="NLBModeIDColumn" msprop:Generator_UserColumnName="NLBModeID" type="xs:int" minOccurs="0" />
              <xs:element name="DBInstanceID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnDBInstanceID" msprop:Generator_ColumnPropNameInRow="DBInstanceID" msprop:Generator_ColumnPropNameInTable="DBInstanceIDColumn" msprop:Generator_UserColumnName="DBInstanceID" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="IPAssign" msprop:Generator_TableClassName="IPAssignDataTable" msprop:Generator_TableVarName="tableIPAssign" msprop:Generator_TablePropName="IPAssign" msprop:Generator_RowDeletingName="IPAssignRowDeleting" msprop:Generator_UserTableName="IPAssign" msprop:Generator_RowChangingName="IPAssignRowChanging" msprop:Generator_RowEvHandlerName="IPAssignRowChangeEventHandler" msprop:Generator_RowDeletedName="IPAssignRowDeleted" msprop:Generator_RowEvArgName="IPAssignRowChangeEvent" msprop:Generator_RowChangedName="IPAssignRowChanged" msprop:Generator_RowClassName="IPAssignRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IPAssignID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msdata:Caption="IPRangeID" msprop:Generator_ColumnVarNameInTable="columnIPAssignID" msprop:Generator_ColumnPropNameInRow="IPAssignID" msprop:Generator_ColumnPropNameInTable="IPAssignIDColumn" msprop:Generator_UserColumnName="IPAssignID" type="xs:string" />
              <xs:element name="IPRangeID" msdata:Caption="IPRange" msprop:Generator_ColumnVarNameInTable="columnIPRangeID" msprop:Generator_ColumnPropNameInRow="IPRangeID" msprop:Generator_ColumnPropNameInTable="IPRangeIDColumn" msprop:Generator_UserColumnName="IPRangeID" type="xs:string" minOccurs="0" />
              <xs:element name="IPAddress" msdata:Caption="StartIP" msprop:Generator_ColumnVarNameInTable="columnIPAddress" msprop:Generator_ColumnPropNameInRow="IPAddress" msprop:Generator_ColumnPropNameInTable="IPAddressColumn" msprop:Generator_UserColumnName="IPAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Netmask" msdata:Caption="EndIP" msprop:Generator_ColumnVarNameInTable="columnNetmask" msprop:Generator_ColumnPropNameInRow="Netmask" msprop:Generator_ColumnPropNameInTable="NetmaskColumn" msprop:Generator_UserColumnName="Netmask" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Gateway" msprop:Generator_ColumnVarNameInTable="columnGateway" msprop:Generator_ColumnPropNameInRow="Gateway" msprop:Generator_ColumnPropNameInTable="GatewayColumn" msprop:Generator_UserColumnName="Gateway" type="xs:string" minOccurs="0" />
              <xs:element name="VlanID" msprop:Generator_ColumnVarNameInTable="columnVlanID" msprop:Generator_ColumnPropNameInRow="VlanID" msprop:Generator_ColumnPropNameInTable="VlanIDColumn" msprop:Generator_UserColumnName="VlanID" type="xs:string" minOccurs="0" />
              <xs:element name="Usage" msprop:Generator_ColumnVarNameInTable="columnUsage" msprop:Generator_ColumnPropNameInRow="Usage" msprop:Generator_ColumnPropNameInTable="UsageColumn" msprop:Generator_UserColumnName="Usage" type="xs:string" minOccurs="0" />
              <xs:element name="DeviceName" msprop:Generator_ColumnVarNameInTable="columnDeviceName" msprop:Generator_ColumnPropNameInRow="DeviceName" msprop:Generator_ColumnPropNameInTable="DeviceNameColumn" msprop:Generator_UserColumnName="DeviceName" type="xs:string" minOccurs="0" />
              <xs:element name="CRQ" msdata:Caption="IPType" msprop:Generator_ColumnVarNameInTable="columnCRQ" msprop:Generator_ColumnPropNameInRow="CRQ" msprop:Generator_ColumnPropNameInTable="CRQColumn" msprop:Generator_UserColumnName="CRQ" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="KvmInfo" msprop:Generator_UserTableName="KvmInfo" msprop:Generator_RowEvArgName="KvmInfoRowChangeEvent" msprop:Generator_TableVarName="tableKvmInfo" msprop:Generator_TablePropName="KvmInfo" msprop:Generator_RowDeletingName="KvmInfoRowDeleting" msprop:Generator_RowChangingName="KvmInfoRowChanging" msprop:Generator_RowDeletedName="KvmInfoRowDeleted" msprop:Generator_TableClassName="KvmInfoDataTable" msprop:Generator_RowChangedName="KvmInfoRowChanged" msprop:Generator_RowEvHandlerName="KvmInfoRowChangeEventHandler" msprop:Generator_RowClassName="KvmInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="KvmID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnKvmID" msprop:Generator_ColumnPropNameInRow="KvmID" msprop:Generator_ColumnPropNameInTable="KvmIDColumn" msprop:Generator_UserColumnName="KvmID" type="xs:string" />
              <xs:element name="AssetNo" msprop:Generator_ColumnVarNameInTable="columnAssetNo" msprop:Generator_ColumnPropNameInRow="AssetNo" msprop:Generator_ColumnPropNameInTable="AssetNoColumn" msprop:Generator_UserColumnName="AssetNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KvmName" msprop:Generator_ColumnVarNameInTable="columnKvmName" msprop:Generator_ColumnPropNameInRow="KvmName" msprop:Generator_ColumnPropNameInTable="KvmNameColumn" msprop:Generator_UserColumnName="KvmName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="KvmPort" msprop:Generator_ColumnVarNameInTable="columnKvmPort" msprop:Generator_ColumnPropNameInRow="KvmPort" msprop:Generator_ColumnPropNameInTable="KvmPortColumn" msprop:Generator_UserColumnName="KvmPort" type="xs:string" minOccurs="0" />
              <xs:element name="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" msprop:Generator_UserColumnName="Brand" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SiteCodeID" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Floors" msprop:Generator_ColumnVarNameInTable="columnFloors" msprop:Generator_ColumnPropNameInRow="Floors" msprop:Generator_ColumnPropNameInTable="FloorsColumn" msprop:Generator_UserColumnName="Floors" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RackID" msprop:Generator_ColumnVarNameInTable="columnRackID" msprop:Generator_ColumnPropNameInRow="RackID" msprop:Generator_ColumnPropNameInTable="RackIDColumn" msprop:Generator_UserColumnName="RackID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WarrantyStartDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyStartDate" msprop:Generator_ColumnPropNameInRow="WarrantyStartDate" msprop:Generator_ColumnPropNameInTable="WarrantyStartDateColumn" msprop:Generator_UserColumnName="WarrantyStartDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WarrantyEndDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyEndDate" msprop:Generator_ColumnPropNameInRow="WarrantyEndDate" msprop:Generator_ColumnPropNameInTable="WarrantyEndDateColumn" msprop:Generator_UserColumnName="WarrantyEndDate" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VendorID" msprop:Generator_ColumnVarNameInTable="columnVendorID" msprop:Generator_ColumnPropNameInRow="VendorID" msprop:Generator_ColumnPropNameInTable="VendorIDColumn" msprop:Generator_UserColumnName="VendorID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="GeneralSoftwareInfo" msprop:Generator_TableClassName="GeneralSoftwareInfoDataTable" msprop:Generator_TableVarName="tableGeneralSoftwareInfo" msprop:Generator_TablePropName="GeneralSoftwareInfo" msprop:Generator_RowDeletingName="GeneralSoftwareInfoRowDeleting" msprop:Generator_UserTableName="GeneralSoftwareInfo" msprop:Generator_RowChangingName="GeneralSoftwareInfoRowChanging" msprop:Generator_RowEvHandlerName="GeneralSoftwareInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="GeneralSoftwareInfoRowDeleted" msprop:Generator_RowEvArgName="GeneralSoftwareInfoRowChangeEvent" msprop:Generator_RowChangedName="GeneralSoftwareInfoRowChanged" msprop:Generator_RowClassName="GeneralSoftwareInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="GeneralSoftwareID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnGeneralSoftwareID" msprop:Generator_ColumnPropNameInRow="GeneralSoftwareID" msprop:Generator_ColumnPropNameInTable="GeneralSoftwareIDColumn" msprop:Generator_UserColumnName="GeneralSoftwareID" type="xs:string" />
              <xs:element name="SiteCodeID" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" type="xs:int" minOccurs="0" />
              <xs:element name="SoftwareName" msprop:Generator_ColumnVarNameInTable="columnSoftwareName" msprop:Generator_ColumnPropNameInRow="SoftwareName" msprop:Generator_ColumnPropNameInTable="SoftwareNameColumn" msprop:Generator_UserColumnName="SoftwareName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SoftwareVersion" msprop:Generator_ColumnVarNameInTable="columnSoftwareVersion" msprop:Generator_ColumnPropNameInRow="SoftwareVersion" msprop:Generator_ColumnPropNameInTable="SoftwareVersionColumn" msprop:Generator_UserColumnName="SoftwareVersion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LicenseID" msprop:Generator_ColumnVarNameInTable="columnLicenseID" msprop:Generator_ColumnPropNameInRow="LicenseID" msprop:Generator_ColumnPropNameInTable="LicenseIDColumn" msprop:Generator_UserColumnName="LicenseID" type="xs:int" minOccurs="0" />
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="WarrantyStartDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyStartDate" msprop:Generator_ColumnPropNameInRow="WarrantyStartDate" msprop:Generator_ColumnPropNameInTable="WarrantyStartDateColumn" msprop:Generator_UserColumnName="WarrantyStartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="WarrantyEndDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyEndDate" msprop:Generator_ColumnPropNameInRow="WarrantyEndDate" msprop:Generator_ColumnPropNameInTable="WarrantyEndDateColumn" msprop:Generator_UserColumnName="WarrantyEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VendorID" msprop:Generator_ColumnVarNameInTable="columnVendorID" msprop:Generator_ColumnPropNameInRow="VendorID" msprop:Generator_ColumnPropNameInTable="VendorIDColumn" msprop:Generator_UserColumnName="VendorID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="PhysicalMachineInfo" msprop:Generator_TableClassName="PhysicalMachineInfoDataTable" msprop:Generator_TableVarName="tablePhysicalMachineInfo" msprop:Generator_TablePropName="PhysicalMachineInfo" msprop:Generator_RowDeletingName="PhysicalMachineInfoRowDeleting" msprop:Generator_UserTableName="PhysicalMachineInfo" msprop:Generator_RowChangingName="PhysicalMachineInfoRowChanging" msprop:Generator_RowEvHandlerName="PhysicalMachineInfoRowChangeEventHandler" msprop:Generator_RowDeletedName="PhysicalMachineInfoRowDeleted" msprop:Generator_RowEvArgName="PhysicalMachineInfoRowChangeEvent" msprop:Generator_RowChangedName="PhysicalMachineInfoRowChanged" msprop:Generator_RowClassName="PhysicalMachineInfoRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PhysicalID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPhysicalID" msprop:Generator_ColumnPropNameInRow="PhysicalID" msprop:Generator_ColumnPropNameInTable="PhysicalIDColumn" msprop:Generator_UserColumnName="PhysicalID" type="xs:string" />
              <xs:element name="ServerTypeID" msprop:Generator_ColumnVarNameInTable="columnServerTypeID" msprop:Generator_ColumnPropNameInRow="ServerTypeID" msprop:Generator_ColumnPropNameInTable="ServerTypeIDColumn" msprop:Generator_UserColumnName="ServerTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="AssetNo" msprop:Generator_ColumnVarNameInTable="columnAssetNo" msprop:Generator_ColumnPropNameInRow="AssetNo" msprop:Generator_ColumnPropNameInTable="AssetNoColumn" msprop:Generator_UserColumnName="AssetNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UniqueNo" msprop:Generator_ColumnVarNameInTable="columnUniqueNo" msprop:Generator_ColumnPropNameInRow="UniqueNo" msprop:Generator_ColumnPropNameInTable="UniqueNoColumn" msprop:Generator_UserColumnName="UniqueNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" msprop:Generator_UserColumnName="Brand" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SiteCodeID" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" type="xs:int" minOccurs="0" />
              <xs:element name="Floors" msprop:Generator_ColumnVarNameInTable="columnFloors" msprop:Generator_ColumnPropNameInRow="Floors" msprop:Generator_ColumnPropNameInTable="FloorsColumn" msprop:Generator_UserColumnName="Floors" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RackID" msprop:Generator_ColumnVarNameInTable="columnRackID" msprop:Generator_ColumnPropNameInRow="RackID" msprop:Generator_ColumnPropNameInTable="RackIDColumn" msprop:Generator_UserColumnName="RackID" type="xs:int" minOccurs="0" />
              <xs:element name="PositionInRack" msprop:Generator_ColumnVarNameInTable="columnPositionInRack" msprop:Generator_ColumnPropNameInRow="PositionInRack" msprop:Generator_ColumnPropNameInTable="PositionInRackColumn" msprop:Generator_UserColumnName="PositionInRack" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="iLOIP" msprop:Generator_ColumnVarNameInTable="columniLOIP" msprop:Generator_ColumnPropNameInRow="iLOIP" msprop:Generator_ColumnPropNameInTable="iLOIPColumn" msprop:Generator_UserColumnName="iLOIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CPU" msprop:Generator_ColumnVarNameInTable="columnCPU" msprop:Generator_ColumnPropNameInRow="CPU" msprop:Generator_ColumnPropNameInTable="CPUColumn" msprop:Generator_UserColumnName="CPU" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RAM" msprop:Generator_ColumnVarNameInTable="columnRAM" msprop:Generator_ColumnPropNameInRow="RAM" msprop:Generator_ColumnPropNameInTable="RAMColumn" msprop:Generator_UserColumnName="RAM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HardDisk" msprop:Generator_ColumnVarNameInTable="columnHardDisk" msprop:Generator_ColumnPropNameInRow="HardDisk" msprop:Generator_ColumnPropNameInTable="HardDiskColumn" msprop:Generator_UserColumnName="HardDisk" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="EnclosureID" msprop:Generator_ColumnVarNameInTable="columnEnclosureID" msprop:Generator_ColumnPropNameInRow="EnclosureID" msprop:Generator_ColumnPropNameInTable="EnclosureIDColumn" msprop:Generator_UserColumnName="EnclosureID" type="xs:int" minOccurs="0" />
              <xs:element name="PduID" msprop:Generator_ColumnVarNameInTable="columnPduID" msprop:Generator_ColumnPropNameInRow="PduID" msprop:Generator_ColumnPropNameInTable="PduIDColumn" msprop:Generator_UserColumnName="PduID" type="xs:int" minOccurs="0" />
              <xs:element name="KvmID" msprop:Generator_ColumnVarNameInTable="columnKvmID" msprop:Generator_ColumnPropNameInRow="KvmID" msprop:Generator_ColumnPropNameInTable="KvmIDColumn" msprop:Generator_UserColumnName="KvmID" type="xs:int" minOccurs="0" />
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WarrantyStartDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyStartDate" msprop:Generator_ColumnPropNameInRow="WarrantyStartDate" msprop:Generator_ColumnPropNameInTable="WarrantyStartDateColumn" msprop:Generator_UserColumnName="WarrantyStartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="WarrantyEndDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyEndDate" msprop:Generator_ColumnPropNameInRow="WarrantyEndDate" msprop:Generator_ColumnPropNameInTable="WarrantyEndDateColumn" msprop:Generator_UserColumnName="WarrantyEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VendorID" msprop:Generator_ColumnVarNameInTable="columnVendorID" msprop:Generator_ColumnPropNameInRow="VendorID" msprop:Generator_ColumnPropNameInTable="VendorIDColumn" msprop:Generator_UserColumnName="VendorID" type="xs:int" minOccurs="0" />
              <xs:element name="VirtualCenter" msprop:Generator_ColumnVarNameInTable="columnVirtualCenter" msprop:Generator_ColumnPropNameInRow="VirtualCenter" msprop:Generator_ColumnPropNameInTable="VirtualCenterColumn" msprop:Generator_UserColumnName="VirtualCenter" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VMVersion" msprop:Generator_ColumnVarNameInTable="columnVMVersion" msprop:Generator_ColumnPropNameInRow="VMVersion" msprop:Generator_ColumnPropNameInTable="VMVersionColumn" msprop:Generator_UserColumnName="VMVersion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="VMClusterName" msprop:Generator_ColumnVarNameInTable="columnVMClusterName" msprop:Generator_ColumnPropNameInRow="VMClusterName" msprop:Generator_ColumnPropNameInTable="VMClusterNameColumn" msprop:Generator_UserColumnName="VMClusterName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BakServerName" msprop:Generator_ColumnVarNameInTable="columnBakServerName" msprop:Generator_ColumnPropNameInRow="BakServerName" msprop:Generator_ColumnPropNameInTable="BakServerNameColumn" msprop:Generator_UserColumnName="BakServerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" msprop:Generator_UserColumnName="Comments" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tbServer" msprop:Generator_TableClassName="tbServerDataTable" msprop:Generator_TableVarName="tabletbServer" msprop:Generator_TablePropName="tbServer" msprop:Generator_RowDeletingName="tbServerRowDeleting" msprop:Generator_UserTableName="tbServer" msprop:Generator_RowChangingName="tbServerRowChanging" msprop:Generator_RowEvHandlerName="tbServerRowChangeEventHandler" msprop:Generator_RowDeletedName="tbServerRowDeleted" msprop:Generator_RowEvArgName="tbServerRowChangeEvent" msprop:Generator_RowChangedName="tbServerRowChanged" msprop:Generator_RowClassName="tbServerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="ServerID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnServerID" msprop:Generator_ColumnPropNameInRow="ServerID" msprop:Generator_ColumnPropNameInTable="ServerIDColumn" msprop:Generator_UserColumnName="ServerID" type="xs:string" />
              <xs:element name="PhysicalID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnPhysicalID" msprop:Generator_ColumnPropNameInRow="PhysicalID" msprop:Generator_ColumnPropNameInTable="PhysicalIDColumn" msprop:Generator_UserColumnName="PhysicalID" type="xs:string" minOccurs="0" />
              <xs:element name="ServerName" msprop:Generator_ColumnVarNameInTable="columnServerName" msprop:Generator_ColumnPropNameInRow="ServerName" msprop:Generator_ColumnPropNameInTable="ServerNameColumn" msprop:Generator_UserColumnName="ServerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Alias" msprop:Generator_ColumnVarNameInTable="columnAlias" msprop:Generator_ColumnPropNameInRow="Alias" msprop:Generator_ColumnPropNameInTable="AliasColumn" msprop:Generator_UserColumnName="Alias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ServerIP" msprop:Generator_ColumnVarNameInTable="columnServerIP" msprop:Generator_ColumnPropNameInRow="ServerIP" msprop:Generator_ColumnPropNameInTable="ServerIPColumn" msprop:Generator_UserColumnName="ServerIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DomainID" msprop:Generator_ColumnVarNameInTable="columnDomainID" msprop:Generator_ColumnPropNameInRow="DomainID" msprop:Generator_ColumnPropNameInTable="DomainIDColumn" msprop:Generator_UserColumnName="DomainID" type="xs:int" minOccurs="0" />
              <xs:element name="OSNameID" msprop:Generator_ColumnVarNameInTable="columnOSNameID" msprop:Generator_ColumnPropNameInRow="OSNameID" msprop:Generator_ColumnPropNameInTable="OSNameIDColumn" msprop:Generator_UserColumnName="OSNameID" type="xs:int" minOccurs="0" />
              <xs:element name="OSVersion" msprop:Generator_ColumnVarNameInTable="columnOSVersion" msprop:Generator_ColumnPropNameInRow="OSVersion" msprop:Generator_ColumnPropNameInTable="OSVersionColumn" msprop:Generator_UserColumnName="OSVersion" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="OSServicePackID" msprop:Generator_ColumnVarNameInTable="columnOSServicePackID" msprop:Generator_ColumnPropNameInRow="OSServicePackID" msprop:Generator_ColumnPropNameInTable="OSServicePackIDColumn" msprop:Generator_UserColumnName="OSServicePackID" type="xs:int" minOccurs="0" />
              <xs:element name="EnvironmentID" msprop:Generator_ColumnVarNameInTable="columnEnvironmentID" msprop:Generator_ColumnPropNameInRow="EnvironmentID" msprop:Generator_ColumnPropNameInTable="EnvironmentIDColumn" msprop:Generator_UserColumnName="EnvironmentID" type="xs:int" minOccurs="0" />
              <xs:element name="CPU" msprop:Generator_ColumnVarNameInTable="columnCPU" msprop:Generator_ColumnPropNameInRow="CPU" msprop:Generator_ColumnPropNameInTable="CPUColumn" msprop:Generator_UserColumnName="CPU" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RAM" msprop:Generator_ColumnVarNameInTable="columnRAM" msprop:Generator_ColumnPropNameInRow="RAM" msprop:Generator_ColumnPropNameInTable="RAMColumn" msprop:Generator_UserColumnName="RAM" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HardDisk" msprop:Generator_ColumnVarNameInTable="columnHardDisk" msprop:Generator_ColumnPropNameInRow="HardDisk" msprop:Generator_ColumnPropNameInTable="HardDiskColumn" msprop:Generator_UserColumnName="HardDisk" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="ScomStatusID" msprop:Generator_ColumnVarNameInTable="columnScomStatusID" msprop:Generator_ColumnPropNameInRow="ScomStatusID" msprop:Generator_ColumnPropNameInTable="ScomStatusIDColumn" msprop:Generator_UserColumnName="ScomStatusID" type="xs:int" minOccurs="0" />
              <xs:element name="PatchStatusID" msprop:Generator_ColumnVarNameInTable="columnPatchStatusID" msprop:Generator_ColumnPropNameInRow="PatchStatusID" msprop:Generator_ColumnPropNameInTable="PatchStatusIDColumn" msprop:Generator_UserColumnName="PatchStatusID" type="xs:int" minOccurs="0" />
              <xs:element name="CVCoverageID" msprop:Generator_ColumnVarNameInTable="columnCVCoverageID" msprop:Generator_ColumnPropNameInRow="CVCoverageID" msprop:Generator_ColumnPropNameInTable="CVCoverageIDColumn" msprop:Generator_UserColumnName="CVCoverageID" type="xs:int" minOccurs="0" />
              <xs:element name="AppCatalog" msprop:Generator_ColumnVarNameInTable="columnAppCatalog" msprop:Generator_ColumnPropNameInRow="AppCatalog" msprop:Generator_ColumnPropNameInTable="AppCatalogColumn" msprop:Generator_UserColumnName="AppCatalog" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HostingTypeID" msprop:Generator_ColumnVarNameInTable="columnHostingTypeID" msprop:Generator_ColumnPropNameInRow="HostingTypeID" msprop:Generator_ColumnPropNameInTable="HostingTypeIDColumn" msprop:Generator_UserColumnName="HostingTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="AppSupportTeam" msprop:Generator_ColumnVarNameInTable="columnAppSupportTeam" msprop:Generator_ColumnPropNameInRow="AppSupportTeam" msprop:Generator_ColumnPropNameInTable="AppSupportTeamColumn" msprop:Generator_UserColumnName="AppSupportTeam" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="BuID" msprop:Generator_ColumnVarNameInTable="columnBuID" msprop:Generator_ColumnPropNameInRow="BuID" msprop:Generator_ColumnPropNameInTable="BuIDColumn" msprop:Generator_UserColumnName="BuID" type="xs:int" minOccurs="0" />
              <xs:element name="BUdetails" msprop:Generator_ColumnVarNameInTable="columnBUdetails" msprop:Generator_ColumnPropNameInRow="BUdetails" msprop:Generator_ColumnPropNameInTable="BUdetailsColumn" msprop:Generator_UserColumnName="BUdetails" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IfCluster" msprop:Generator_ColumnVarNameInTable="columnIfCluster" msprop:Generator_ColumnPropNameInRow="IfCluster" msprop:Generator_ColumnPropNameInTable="IfClusterColumn" msprop:Generator_UserColumnName="IfCluster" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ServerTypeID" msprop:Generator_ColumnVarNameInTable="columnServerTypeID" msprop:Generator_ColumnPropNameInRow="ServerTypeID" msprop:Generator_ColumnPropNameInTable="ServerTypeIDColumn" msprop:Generator_UserColumnName="ServerTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="ClusterID" msprop:Generator_ColumnVarNameInTable="columnClusterID" msprop:Generator_ColumnPropNameInRow="ClusterID" msprop:Generator_ColumnPropNameInTable="ClusterIDColumn" msprop:Generator_UserColumnName="ClusterID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tbNetwork" msprop:Generator_TableClassName="tbNetworkDataTable" msprop:Generator_TableVarName="tabletbNetwork" msprop:Generator_TablePropName="tbNetwork" msprop:Generator_RowDeletingName="tbNetworkRowDeleting" msprop:Generator_UserTableName="tbNetwork" msprop:Generator_RowChangingName="tbNetworkRowChanging" msprop:Generator_RowEvHandlerName="tbNetworkRowChangeEventHandler" msprop:Generator_RowDeletedName="tbNetworkRowDeleted" msprop:Generator_RowEvArgName="tbNetworkRowChangeEvent" msprop:Generator_RowChangedName="tbNetworkRowChanged" msprop:Generator_RowClassName="tbNetworkRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="NetworkID" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:Generator_ColumnVarNameInTable="columnNetworkID" msprop:Generator_ColumnPropNameInRow="NetworkID" msprop:Generator_ColumnPropNameInTable="NetworkIDColumn" msprop:Generator_UserColumnName="NetworkID" type="xs:string" />
              <xs:element name="TypeID" msprop:Generator_ColumnVarNameInTable="columnTypeID" msprop:Generator_ColumnPropNameInRow="TypeID" msprop:Generator_ColumnPropNameInTable="TypeIDColumn" msprop:Generator_UserColumnName="TypeID" type="xs:int" minOccurs="0" />
              <xs:element name="AssetNo" msprop:Generator_ColumnVarNameInTable="columnAssetNo" msprop:Generator_ColumnPropNameInRow="AssetNo" msprop:Generator_ColumnPropNameInTable="AssetNoColumn" msprop:Generator_UserColumnName="AssetNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UniqueNo" msprop:Generator_ColumnVarNameInTable="columnUniqueNo" msprop:Generator_ColumnPropNameInRow="UniqueNo" msprop:Generator_ColumnPropNameInTable="UniqueNoColumn" msprop:Generator_UserColumnName="UniqueNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" msprop:Generator_UserColumnName="Brand" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Model" msprop:Generator_ColumnVarNameInTable="columnModel" msprop:Generator_ColumnPropNameInRow="Model" msprop:Generator_ColumnPropNameInTable="ModelColumn" msprop:Generator_UserColumnName="Model" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SiteCodeID" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" type="xs:int" minOccurs="0" />
              <xs:element name="Floors" msprop:Generator_ColumnVarNameInTable="columnFloors" msprop:Generator_ColumnPropNameInRow="Floors" msprop:Generator_ColumnPropNameInTable="FloorsColumn" msprop:Generator_UserColumnName="Floors" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RackID" msprop:Generator_ColumnVarNameInTable="columnRackID" msprop:Generator_ColumnPropNameInRow="RackID" msprop:Generator_ColumnPropNameInTable="RackIDColumn" msprop:Generator_UserColumnName="RackID" type="xs:int" minOccurs="0" />
              <xs:element name="PositionInRack" msprop:Generator_ColumnVarNameInTable="columnPositionInRack" msprop:Generator_ColumnPropNameInRow="PositionInRack" msprop:Generator_ColumnPropNameInTable="PositionInRackColumn" msprop:Generator_UserColumnName="PositionInRack" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ManageIP" msprop:Generator_ColumnVarNameInTable="columnManageIP" msprop:Generator_ColumnPropNameInRow="ManageIP" msprop:Generator_ColumnPropNameInTable="ManageIPColumn" msprop:Generator_UserColumnName="ManageIP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Capacity100Mbps" msprop:Generator_ColumnVarNameInTable="columnCapacity100Mbps" msprop:Generator_ColumnPropNameInRow="Capacity100Mbps" msprop:Generator_ColumnPropNameInTable="Capacity100MbpsColumn" msprop:Generator_UserColumnName="Capacity100Mbps" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Capacity1Gbps" msprop:Generator_ColumnVarNameInTable="columnCapacity1Gbps" msprop:Generator_ColumnPropNameInRow="Capacity1Gbps" msprop:Generator_ColumnPropNameInTable="Capacity1GbpsColumn" msprop:Generator_UserColumnName="Capacity1Gbps" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Capacity10Gbps" msprop:Generator_ColumnVarNameInTable="columnCapacity10Gbps" msprop:Generator_ColumnPropNameInRow="Capacity10Gbps" msprop:Generator_ColumnPropNameInTable="Capacity10GbpsColumn" msprop:Generator_UserColumnName="Capacity10Gbps" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UplinkInfo" msprop:Generator_ColumnVarNameInTable="columnUplinkInfo" msprop:Generator_ColumnPropNameInRow="UplinkInfo" msprop:Generator_ColumnPropNameInTable="UplinkInfoColumn" msprop:Generator_UserColumnName="UplinkInfo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="HostingTypeID" msprop:Generator_ColumnVarNameInTable="columnHostingTypeID" msprop:Generator_ColumnPropNameInRow="HostingTypeID" msprop:Generator_ColumnPropNameInTable="HostingTypeIDColumn" msprop:Generator_UserColumnName="HostingTypeID" type="xs:int" minOccurs="0" />
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="PduID" msprop:Generator_ColumnVarNameInTable="columnPduID" msprop:Generator_ColumnPropNameInRow="PduID" msprop:Generator_ColumnPropNameInTable="PduIDColumn" msprop:Generator_UserColumnName="PduID" type="xs:int" minOccurs="0" />
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WarrantyStartDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyStartDate" msprop:Generator_ColumnPropNameInRow="WarrantyStartDate" msprop:Generator_ColumnPropNameInTable="WarrantyStartDateColumn" msprop:Generator_UserColumnName="WarrantyStartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="WarrantyEndDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyEndDate" msprop:Generator_ColumnPropNameInRow="WarrantyEndDate" msprop:Generator_ColumnPropNameInTable="WarrantyEndDateColumn" msprop:Generator_UserColumnName="WarrantyEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VendorID" msprop:Generator_ColumnVarNameInTable="columnVendorID" msprop:Generator_ColumnPropNameInRow="VendorID" msprop:Generator_ColumnPropNameInTable="VendorIDColumn" msprop:Generator_UserColumnName="VendorID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tbEnclosure" msprop:Generator_TableClassName="tbEnclosureDataTable" msprop:Generator_TableVarName="tabletbEnclosure" msprop:Generator_TablePropName="tbEnclosure" msprop:Generator_RowDeletingName="tbEnclosureRowDeleting" msprop:Generator_UserTableName="tbEnclosure" msprop:Generator_RowChangingName="tbEnclosureRowChanging" msprop:Generator_RowEvHandlerName="tbEnclosureRowChangeEventHandler" msprop:Generator_RowDeletedName="tbEnclosureRowDeleted" msprop:Generator_RowEvArgName="tbEnclosureRowChangeEvent" msprop:Generator_RowChangedName="tbEnclosureRowChanged" msprop:Generator_RowClassName="tbEnclosureRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EnclosureID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnEnclosureID" msprop:Generator_ColumnPropNameInRow="EnclosureID" msprop:Generator_ColumnPropNameInTable="EnclosureIDColumn" msprop:Generator_UserColumnName="EnclosureID" type="xs:int" />
              <xs:element name="AssetNo" msprop:Generator_ColumnVarNameInTable="columnAssetNo" msprop:Generator_ColumnPropNameInRow="AssetNo" msprop:Generator_ColumnPropNameInTable="AssetNoColumn" msprop:Generator_UserColumnName="AssetNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="EnclosureName" msprop:Generator_ColumnVarNameInTable="columnEnclosureName" msprop:Generator_ColumnPropNameInRow="EnclosureName" msprop:Generator_ColumnPropNameInTable="EnclosureNameColumn" msprop:Generator_UserColumnName="EnclosureName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StatusID" msprop:Generator_ColumnVarNameInTable="columnStatusID" msprop:Generator_ColumnPropNameInRow="StatusID" msprop:Generator_ColumnPropNameInTable="StatusIDColumn" msprop:Generator_UserColumnName="StatusID" type="xs:int" minOccurs="0" />
              <xs:element name="Brand" msprop:Generator_ColumnVarNameInTable="columnBrand" msprop:Generator_ColumnPropNameInRow="Brand" msprop:Generator_ColumnPropNameInTable="BrandColumn" msprop:Generator_UserColumnName="Brand" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SiteCodeID" msprop:Generator_ColumnVarNameInTable="columnSiteCodeID" msprop:Generator_ColumnPropNameInRow="SiteCodeID" msprop:Generator_ColumnPropNameInTable="SiteCodeIDColumn" msprop:Generator_UserColumnName="SiteCodeID" type="xs:int" minOccurs="0" />
              <xs:element name="Floors" msprop:Generator_ColumnVarNameInTable="columnFloors" msprop:Generator_ColumnPropNameInRow="Floors" msprop:Generator_ColumnPropNameInTable="FloorsColumn" msprop:Generator_UserColumnName="Floors" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SN" msprop:Generator_ColumnVarNameInTable="columnSN" msprop:Generator_ColumnPropNameInRow="SN" msprop:Generator_ColumnPropNameInTable="SNColumn" msprop:Generator_UserColumnName="SN" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="UUID" msprop:Generator_ColumnVarNameInTable="columnUUID" msprop:Generator_ColumnPropNameInRow="UUID" msprop:Generator_ColumnPropNameInTable="UUIDColumn" msprop:Generator_UserColumnName="UUID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PartNumber" msprop:Generator_ColumnVarNameInTable="columnPartNumber" msprop:Generator_ColumnPropNameInRow="PartNumber" msprop:Generator_ColumnPropNameInTable="PartNumberColumn" msprop:Generator_UserColumnName="PartNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WarrantyStartDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyStartDate" msprop:Generator_ColumnPropNameInRow="WarrantyStartDate" msprop:Generator_ColumnPropNameInTable="WarrantyStartDateColumn" msprop:Generator_UserColumnName="WarrantyStartDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="WarrantyEndDate" msprop:Generator_ColumnVarNameInTable="columnWarrantyEndDate" msprop:Generator_ColumnPropNameInRow="WarrantyEndDate" msprop:Generator_ColumnPropNameInTable="WarrantyEndDateColumn" msprop:Generator_UserColumnName="WarrantyEndDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="VendorID" msprop:Generator_ColumnVarNameInTable="columnVendorID" msprop:Generator_ColumnPropNameInRow="VendorID" msprop:Generator_ColumnPropNameInTable="VendorIDColumn" msprop:Generator_UserColumnName="VendorID" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IPRange" />
      <xs:field xpath="mstns:IPRangeID" />
    </xs:unique>
    <xs:unique name="SiteCodeInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:SiteCodeInfo" />
      <xs:field xpath="mstns:SiteCodeID" />
    </xs:unique>
    <xs:unique name="DBInstanceInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DBInstanceInfo" />
      <xs:field xpath="mstns:DBInstanceID" />
    </xs:unique>
    <xs:unique name="DatabaseInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:DatabaseInfo" />
      <xs:field xpath="mstns:DatabaseID" />
    </xs:unique>
    <xs:unique name="ClusterServerInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:ClusterServerInfo" />
      <xs:field xpath="mstns:ClusterID" />
    </xs:unique>
    <xs:unique name="IPAssign_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:IPAssign" />
      <xs:field xpath="mstns:IPAssignID" />
    </xs:unique>
    <xs:unique name="KvmInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:KvmInfo" />
      <xs:field xpath="mstns:KvmID" />
    </xs:unique>
    <xs:unique name="GeneralSoftwareInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:GeneralSoftwareInfo" />
      <xs:field xpath="mstns:GeneralSoftwareID" />
    </xs:unique>
    <xs:unique name="PhysicalMachineInfo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:PhysicalMachineInfo" />
      <xs:field xpath="mstns:PhysicalID" />
    </xs:unique>
    <xs:unique name="tbServer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tbServer" />
      <xs:field xpath="mstns:ServerID" />
    </xs:unique>
    <xs:unique name="tbNetwork_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tbNetwork" />
      <xs:field xpath="mstns:NetworkID" />
    </xs:unique>
    <xs:unique name="tbEnclosure_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tbEnclosure" />
      <xs:field xpath="mstns:EnclosureID" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tbServer_PhysicalServerInfo" msdata:parent="PhysicalMachineInfo" msdata:child="tbServer" msdata:parentkey="PhysicalID" msdata:childkey="PhysicalID" msprop:Generator_UserChildTable="tbServer" msprop:Generator_ChildPropName="GettbServerRows" msprop:Generator_ParentPropName="PhysicalMachineInfoRow" msprop:Generator_UserRelationName="FK_tbServer_PhysicalServerInfo" msprop:Generator_RelationVarName="relationFK_tbServer_PhysicalServerInfo" msprop:Generator_UserParentTable="PhysicalMachineInfo" />
      <msdata:Relationship name="FK_PhysicalServerInfo_tbEnclosure" msdata:parent="tbEnclosure" msdata:child="PhysicalMachineInfo" msdata:parentkey="EnclosureID" msdata:childkey="EnclosureID" msprop:Generator_UserChildTable="PhysicalMachineInfo" msprop:Generator_ChildPropName="GetPhysicalMachineInfoRows" msprop:Generator_ParentPropName="tbEnclosureRow" msprop:Generator_UserRelationName="FK_PhysicalServerInfo_tbEnclosure" msprop:Generator_RelationVarName="relationFK_PhysicalServerInfo_tbEnclosure" msprop:Generator_UserParentTable="tbEnclosure" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>